Pct Free
Specify a whole number representing the percentage of space in each data block of the database object reserved for future updates to rows of the object. The value must be from 0 to 99. A value of 0 means that the entire block can be filled by inserts of new rows. The default value is 10.
Pct Used
Specify a whole number representing the minimum percentage of used space that Oracle maintains for each data block of the database object. A block becomes a candidate for row insertion when its used space falls below this value. The value must be from 0 to 99 and defaults to 40.
Ini Trans
Specify the initial number of concurrent transaction entries allocated within each data block allocated to the database object. This value can range from 1 to 255 and defaults to 1.
Note: The default value for an index is 2.
Max Trans
Specify the maximum number of concurrent update transactions allowed for each data block in the segment.
Storage Options
Initial
Specify the size of the first extent of the object. Use the dropdown list K or M to specify the size in kilobytes or megabytes. If you do not specify any of the abbreviations, then the size is interpreted as bytes.Next
Specify the size of the next extent to be allocated to the object. Use the dropdown list K or M to specify the size in kilobytes or megabytes. If you do not specify any of the abbreviations, then the size is interpreted as bytes.Min
Specify the total number of extents to allocate when the object is created.Max
Specify the total number of extents, including the first, that Oracle can allocate for the object. Check Unlimited if you want extents to be allocated automatically as needed.Pct Increase
Specify the percent by which the third and subsequent extents grow over the preceding extent. The default value is 50.Buffer Pool
KEEP
Choose this to put blocks from the segment into the KEEP buffer pool. Maintaining an appropriately sized KEEP buffer pool lets Oracle retain the schema object in memory to avoid I/O operations. KEEP takes precedence over any NOCACHE clause you specify for a table, cluster, materialized view, or materialized view log.RECYCLE
Choose this to put blocks from the segment into the RECYCLE pool. An appropriately sized RECYCLE pool reduces the number of objects whose default pool is the RECYCLE pool from taking up unnecessary cache space.Free Lists
For objects other than tablespaces and rollback segments, specify the number of free lists for each of the free list groups for the table, partition, cluster, or index.Free List Groups
Specify the number of groups of free lists for the database object you are creating. The default and minimum value for this parameter is 1.